How to: Set a horizontal page break on a worksheet.
Solution:
Select the row just below where the horizontal break is to be inserted and select 'Page Break' from the 'Insert' menu.
1) Select the row just below where the horizontal break is to be inserted. (The entire row is highlighted.)
2) Select the 'Insert' menu and select 'Page Break'. (The worksheet is horizontally split into separate pages at the break.)
NOTE: Manual page breaks are fixed and appear on the screen as dashed lines. Automatic page breaks automatically adjust when manual page breaks are inserted into a worksheet. Automatic page breaks appear as dotted lines.
